ADO CONNECTION Assistant

ADO CONNECTION Assistant
Now - here's the really powerful part - the ADO Connection Assistant (F2)
When this dialog box comes up, you enter your Variables for your connection, Recordset, DSN (or DSN-less connection), and SQL Statement. You can build your own SQL statement manually here, if you want. If you click DSN-less connection, you and you are using an Access database, you can choose and use a local copy of the database in this feature. If you choose it here, the database will automatically carry over to the SQL statement builder Assistant - click on 'Select' so you can get help building your Select and Insert SQL statements.

Click on the DSN-Less check box to bring up the 'Connect To Database' Dialog. Here, you'll choose between MS Access or SQL Server to directly gather the pertinent information in order to connect to your particular database.

Click on the 'Add Delete/Edit' checkbox in order to create separate files for Search results, Editing and Deleting data based on your SQL Query.

The output section allows you to choose how you want to view your actual output. Your three choices are:
HTML Table, Select List (form), and None

Clicking on the 'Enter Request Strings' button will bring up the Request Object Assistant. This will allow you to assign all the 'request.form' variables you need for your form.